package com.cpi.cornpp.instructionspurchases.dto;

import java.io.Serializable;

public class InstructionPurchaseSearchDTO implements Serializable {
	private static final long serialVersionUID = -1194146357657492213L;
	public static String REFERENCE_ORDER = "pih.purchase_instruction_id";//$NON-NLS-1$
	public static String STATUS_ORDER = "pih.status";//$NON-NLS-1$
	public static String LINE_ORDER = "pid.row";//$NON-NLS-1$
	public static String BALANCE_FIELD = "( isnull((select sum( quantity)  from purchases_instructions_futures where purchase_instruction_detail_id = pid.purchase_instruction_detail_id),0) - (select isnull( sum(cf.quantity),0) from purchases_instructions_details pid inner join purchases_instructions_futures pif on pid.purchase_instruction_detail_id = pif.purchase_instruction_detail_id inner join realizeds_instructions ri on pif.purchase_instruction_future_id = ri.purchase_instruction_future_id inner join corn_futures cf on cf.corn_future_id = ri.corn_future_id) )";//$NON-NLS-1$
	private String customer;
	private String item;
	private String reference;
	private int purchaseStatus;
	private int purchaseDetailStatus;
	private String balance;
	public String getCustomer() {
		return customer;
	}
	public void setCustomer(String customer) {
		this.customer = customer;
	}
	public String getItem() {
		return item;
	}
	public void setItem(String item) {
		this.item = item;
	}
	public String getReference() {
		return reference;
	}
	public void setReference(String reference) {
		this.reference = reference;
	}
	public int getPurchaseStatus() {
		return purchaseStatus;
	}
	public void setPurchaseStatus(int purchaseStatus) {
		this.purchaseStatus = purchaseStatus;
	}
	public int getPurchaseDetailStatus() {
		return purchaseDetailStatus;
	}
	public void setPurchaseDetailStatus(int purchaseDetailStatus) {
		this.purchaseDetailStatus = purchaseDetailStatus;
	}
	public String getBalance() {
		return balance;
	}
	public void setBalance(String balance) {
		this.balance = balance;
	}
}